Create Dimensions and Facts tables in OLAP Database and Populate Dimensions and Facts Tables 10


Run Script that is attached to create your Dictionary tables in the ODS Database. Once ran, the tables will be made up of these columns.

Dim_Tables



Stored Procedures



Dim_BorrowerDetails


Dim_BankDetails


Dim_BusinessDetails


Repeat the same Process for all the Dim Tables.


Completed SSIS Package

Results In SSMS



Fact Tables 






Fact Table SSIS PACKAGES







Referential Integrity

https://database.guide/what-is-referential-integrity/